create external table jms_ods.ep_staff_base_salary (
   id bigint comment '主键id',
   regional_code string comment '虚拟代理区编码',
   regional_name string comment '虚拟代理区名称',
   agent_code string comment '代理区编码',
   agent_name string comment '代理区名称',
   network_code string comment '中心编码',
   network_name string comment '中心名称',
   department string comment '部门',
   post string comment '岗位',
   staff_id bigint comment '员工id',
   salary_type smallint comment '工资类型（1-固定 2-非固定）',
   salary decimal(8,2) comment '工资',
   effective_time timestamp comment '生效时间',
   ineffective_time TIMESTAMP comment '失效时间',
   remark string comment '备注',
   create_by bigint comment '创建人',
   create_by_name string comment '创建人姓名',
   create_time TIMESTAMP comment '创建时间',
   modify_by bigint comment '更新人',
   modify_by_name string comment '更新人姓名',
   modify_time TIMESTAMP comment '更新时间'
)
comment '员工基本工资表'
PARTITIONED BY (
  `dt` string COMMENT '时间分区')
ROW FORMAT SERDE
  'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
STORED AS INPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
OUTPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION
  '/dw/hive/jms_ods.db/external/ep_staff_base_salary';
